æ¾ç¤ºmysqlæ°æ®åºè¡¨çå
容éè¦ææ°æ®åºä¸åå°çsqlå
容ç¨system.out.printã
以ä¸æ¯ä¾åï¼
package test;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
/*使ç¨JDBCè¿æ¥æ°æ®åºMySQLçè¿ç¨
* DataBase:hj
* table:student
* */
public class Databasetest {
private static int count;
public static Connection getConnection() throws SQLException,
java.lang.ClassNotFoundException
{
//(1)å è½½MySQLçJDBCçé©±å¨ Class.forName("com.mysql.jdbc.Driver");
//åå¾è¿æ¥çurl,è½è®¿é®MySQLæ°æ®åºçç¨æ·å,å¯ç ,æ°æ®åºå
String url = "jdbc:mysql://127.0.0.1:3306/"+"hj?useUnicode=true&characterEncoding=utf8";
String username = "root";
String password ="";
//(2)å建ä¸MySQLæ°æ®åºçè¿æ¥ç±»çå®ä¾
Connection con = (Connection) DriverManager.getConnection(url, username, password);
return con;
}
public static void main(String args[]) {
try
{
//(3)è·åè¿æ¥å®ä¾con,ç¨conå建Statement对象å®ä¾ sql_statement
Connection con = getConnection();
Statement sql_statement = (Statement) con.createStatement();
//æå
¥è¯å¥
String sql = "insert into student(id,name,score)values(null,'梵èåçå',99)";
count=sql_statement.executeUpdate(sql);
//(4)æ§è¡æ¥è¯¢,ç¨ResultSetç±»ç对象,è¿åæ¥è¯¢ç»æ
String query = "select * from student";
ResultSet result = sql_statement.executeQuery(query);
System.out.println("student表æ°æ®å¦ä¸:");
System.out.println("------------------------");
System.out.println("å¦å·" + " " + "å§å" + " " + "æ绩");
System.out.println("------------------------");
//对è·å¾çæ¥è¯¢ç»æè¿è¡å¤ç,对Resultç±»ç对象è¿è¡æä½
while (result.next())
{
int number=result.getInt("id");
String name=result.getString("name");
String score=result.getString("score");
//åå¾æ°æ®åºä¸çæ°æ® System.out.println("å¦å·: " + number + " å§å: " + name + " æ绩: " + score);
}
//å
³éè¿æ¥å声æ sql_statement.close();
con.close();
} catch(java.lang.ClassNotFoundException e) {
//å è½½JDBCé误,æè¦ç¨ç驱å¨æ²¡ææ¾å°
System.err.print("ClassNotFoundException");
//å
¶ä»é误
System.err.println(e.getMessage());
} catch (SQLException ex) {
//æ¾ç¤ºæ°æ®åºè¿æ¥é误ææ¥è¯¢é误
System.err.println("SQLException: " + ex.getMessage());
}
}
}
è¿è¡ç»æï¼
student表æ°æ®å¦ä¸:
------------------------
å¦å· å§å æ绩
001 å¼ ä¸ 90
温馨提示:内容为网友见解,仅供参考