java登录界面 sql数据库_软件工程概论01：JavaWeb连接SQLServer数据库并完成一个登录界面及其功能设计。...

1.连接数据库

package com.jaovo.msg.Util;

import java.sql.*;

public class DBUtil {

public static Connection getConnection() {

//加载驱动

String dbDrive="com.mysql.jdbc.Driver";

try {

try {

Class.forName(dbDrive).newInstance();

} catch (InstantiationException e) {

e.printStackTrace();

} catch (IllegalAccessException e) {

e.printStackTrace();

}

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

//连接数据库

Connection connection=null;

String url="jdbc:mysql://localhost:3307/l_user";

try {

connection=DriverManager.getConnection(url,"root","root");

} catch (SQLException e) {

e.printStackTrace();

}

return connection;

}

public static void close(Connection connection ) {

try {

if (connection != null) {

connection.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static void close(PreparedStatement preparedStatement ) {

try {