求java进销存代码要与MySql数据库连接,哪位朋友有，请帮帮忙！！！

我封装的DB类importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;publicclassmySQLDB{publicstaticConnectiongetConn(){Connectionconn=null;try{Class.forName("com.mysql.jdbc.Driver");conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/myBBS","root","root");}catch(ClassNotFoundExceptione){e.printStackTrace();}catch(SQLExceptione){e.printStackTrace();}returnconn;}publicstaticStatementcreateStmt(Connectionconn){Statementstmt=null;try{stmt=conn.createStatement();}catch(SQLExceptione){e.printStackTrace();}returnstmt;}publicstaticResultSetexecuteQuery(Statementstmt,Stringsql){ResultSetrs=null;try{rs=stmt.executeQuery(sql);}catch(SQLExceptione){e.printStackTrace();}returnrs;}publicstaticPreparedStatementprepareStmt(Connectionconn,Stringsql){PreparedStatementpstmt=null;try{pstmt=conn.prepareStatement(sql);}catch(SQLExceptione){e.printStackTrace();}returnpstmt;}publicstaticvoidclose(Connectionionconn){if(conn!=null){try{conn.close();}catch(SQLExceptione){e.printStackTrace();}conn=null;}}publicstaticvoidclose(Statementstmt){if(stmt!=null){尝试{stmt.close();}catch(SQLExceptione){e.printStackTrace();}stmt=null;}}publicstaticvoidclose(ResultSetrs){if(rs!=null){try{rs.close();}catch(SQLExceptione){e.printStackTrace();}rs=null;}}}

java链接mysql数据库url怎么写(mysql数据库连接url)

连接代码如下：

publicstaticvoidmain(String[]args){

//drivername

Stringdriver="com.mysql.jdbc.Driver";

//URL指向访问数据库名称scutcs

Stringurl="jdbc:mysql://127.0.0.1:3306/scutcs";

//MySQL配置时的用户名

Stringuser="root";

//配置MySQL时Password

Stringpassword="root";

try{

//加载驱动

//连续数据库

Connectionconn=.(url,user,password);

if(!conn.isClosed())

System.out.println("SuededconnectingtotheDatabase!");

//该语句用于运行SQL语句

Statementstatement=conn.();

//要执行的SQL语句

Stringsql="select*fromstudent";

//结果集

ResultSetrs=statement.(sql);

System.out.println("------------------");

System.out.println("执行结果如下：");

System.out.println("----------------");

System.out.println("学号"""姓名");

System.out.println("-----------------");

Stringname=null;

while(rs.next()){

//选择Sname列数据from

name=rs.getString("sname");

//首先使用ISO-8859-1字符集将name解码为字节序列并保存结果

//然后使用GB2312字符集创建指定的字节数组。
解码

name=newString(name.getBytes("ISO-8859-1"),"GB2312");

//输出结果

System.out.println(rs.getString("sno")""name);

}

rs.close();

conn.close();

}catch(e){

System.out.println("抱歉，我找不到驱动程序！");

e.();

}catch(e){

e.();

}catch(例外）{

e.();

}