有的时候用到就忘了,特此记下!
(mysql数据库)获得jdbc连接:
查询样例:
随便参考:[url]http://leeldy.blog.163.com/blog/static/139853062009710115938902/[/url]
(mysql数据库)获得jdbc连接:
static Connection conn = null;
public static Connection getConnection() {
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/upload", "root", "123456");
return conn;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
查询样例:
public List<Tests> getAll()throws Exception
{
List<Tests> list = new ArrayList<Tests>();
Connection connection = getConnection();
Statement statament = connection.createStatement();
ResultSet rs = statament.executeQuery( "select * from tests" );
while(rs.next()){
String ids = rs.getString("id");
int id = Integer.parseInt(ids);
String names = rs.getString("names");
String sex = rs.getString("sex");
String email = rs.getString("email");
String blog = rs.getString("blog");
Tests tests = new Tests(id, names, sex, email, blog);
list.add(tests);
}
return list;
}
随便参考:[url]http://leeldy.blog.163.com/blog/static/139853062009710115938902/[/url]