package com.jdbc.connection;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Scanner;
class User
{
static String userName;
static String userpassWord;
public static void landing()
{
System.out.println("please enter userName: ");
Scanner scan = new Scanner(System.in);
userName = scan.next();
System.out.println("please enter userName: ");
Scanner scan1 = new Scanner(System.in);
userpassWord = scan1.next();
if(userName.equals("sa") && userpassWord.equals("java"))
{
System.out.println("login sucess");
}
else
{
System.out.println("login erro!!");
}
}
}
public class DatabaseConnection
{
public static void Conection()
{
Connection con = null;
String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=haifei";
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection(URL,User.userName,User.userpassWord);
System.out.println("connection sucess----!!");
}
catch(Exception e)
{
e.printStackTrace();
}
}
public static void main(String[] args)
{
User.landing();
DatabaseConnection.Conection();
}
}我是想添加一个方法用来注册.
主要就是来存储用户名和密码高手指点一下看看这个这个程序应该怎么改
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Scanner;
class User
{
static String userName;
static String userpassWord;
public static void landing()
{
System.out.println("please enter userName: ");
Scanner scan = new Scanner(System.in);
userName = scan.next();
System.out.println("please enter userName: ");
Scanner scan1 = new Scanner(System.in);
userpassWord = scan1.next();
if(userName.equals("sa") && userpassWord.equals("java"))
{
System.out.println("login sucess");
}
else
{
System.out.println("login erro!!");
}
}
}
public class DatabaseConnection
{
public static void Conection()
{
Connection con = null;
String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=haifei";
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection(URL,User.userName,User.userpassWord);
System.out.println("connection sucess----!!");
}
catch(Exception e)
{
e.printStackTrace();
}
}
public static void main(String[] args)
{
User.landing();
DatabaseConnection.Conection();
}
}我是想添加一个方法用来注册.
主要就是来存储用户名和密码高手指点一下看看这个这个程序应该怎么改
public class DatabaseConnection
{
private Connection conn ;
private static final String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=haifei";
private static final String Driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String userName = "sa";
private static final String userPwd = "java"; public static void Conection()
{
try
{
Class.forName(Driver); //这里连接时,用户名和密码应该只能为sa和java?否则无法连接
con = DriverManager.getConnection(URL,userName,userPwd);
System.out.println("connection sucess----!!");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
} public static int registe(String uName,String uPwd){
if(conn == null){
Conection();
}
int result = 0;
Statement stmt = null;
Transaction tran = null;
try{
tran = conn.beginTransaction();
stmt = conn.createStatement("insert into Tb_user values('" + uName + "','" + uPwd + "'");//这里用PrepredStatement更好些
reslut = stmt.executeNonQuery();
tran.commit();
}catch(SQLException e){
tran.rollback();
e.printStackTrace();
}finally{
try{
if(stmt != null){
stmt.close();
}
if(tran != null){
tran.close();
}
if(conn != null){
conn.close();
}
}catch(SQLException e){
e.printStackTrace();
}
}
} public static void main(String[] args)
{
User.landing();
}
}class User{
....
....
public static void landing(){
....
String result = "registe Failue!"; if(DatabaseConnection.registe(userName,userPassword)>0){
//注册成功
result = "registe Success!";
} System.out.println(result);
}
}