- 论坛徽章:
- 0
|
JBuilder 连接 MySql
JAVA怎么连?
- import="java.sql.*";
- Class.forName("org.gjt.mm.mysql.Driver").newInstance();
- String url ="jdbc:mysql://localhost/softforum?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1"
- //testDB为你的数据库名
- Connection conn= DriverManager.getConnection(url);
- Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
- String sql="select * from test";
- ResultSet rs=stmt.executeQuery(sql);
- while(rs.next()){ rs.getString(1)
- rs.getString(2)
- }
- stmt.close();
- conn.close();
复制代码 |
|