我建好了数据库和表,也做好了网页,安装了mysql数据库和tomcat以及jdk,我下一步该怎么演示?
来源:百度知道 编辑:UC知道 时间:2024/06/15 18:31:18
下一步就是连数据库了。
给一个程序给你:
1. 添加连接数据库jar包
2. 稍微修改一下程序
import java.sql.*;
public class ConnectDemoMysql {
private static ConnectDemoMysql instence = null;
private ConnectDemoMysql(){}
public static ConnectDemoMysql getInstence(){
if(instence==null){
instence = new ConnectDemoMysql();
}
return instence;
}
public Connection getConnection(String database){
Connection conn = null;
String mysqldriverName = "com.mysql.jdbc.Driver";
String mysqlurl = "jdbc:mysql://localhost:3306/"+database;
try {
Class.forName(mysqldriverName);
conn = DriverManager.getConnection(mysqlurl,"root","adminadmin");//mysql密码
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public static void main(String args[]){
Connection conn = ConnectDemoMysql.getInstence().getConnection("my