3.29学习总结

package train;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSetMetaData;
import java.util.ArrayList;
import java.util.List;

public class Train
{

public String l_search(int m,String line) throws Exception {
String a = null;
String sql = "SELECT * FROM train where line like '%"+line+"%'" ;


Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/abc";
String username= "root";
String Password= "123123";


Connection connection = DriverManager.getConnection(url, username, Password);
java.sql.Statement stmt = connection.createStatement();

java.sql.ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
a = rs.getString(m);

stmt.close();
rs.close();

return a;

}
public List<String> t_search(String station) throws Exception {
String sql = "SELECT * FROM train" ;
List<String> s=new ArrayList<>();

Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/abc";
String username= "root";
String Password= "123123";


Connection connection = DriverManager.getConnection(url, username, Password);
java.sql.Statement stmt = connection.createStatement();
java.sql.ResultSet rs = stmt.executeQuery(sql);

ResultSetMetaData rsmd = rs.getMetaData() ;
while(rs.next())
{
for(int i=1;i<rsmd.getColumnCount();i++)
{
if(rs.getString(i).equals(station))
s.add(rs.getString(1));
}
}

stmt.close();
rs.close();
return s;

}

public void add(String line,String sta1,String sta2,String sta3,String sta4,String sta5,String sta6,String sta7,String sta8) throws Exception {
String sql = "INSERT into train VALUES('"+line+"','"+sta1+"','"+sta2+"','"+sta3+"','"+sta4+"','"+sta5+"','"+sta6+"','"+sta7+"','"+sta8+"')";


Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/abc";
String username = "root";
String Password = "123123";

Connection connection = DriverManager.getConnection(url, username, Password);
java.sql.Statement stmt = connection.createStatement();

stmt.executeUpdate(sql);
stmt.close();
}


}