Java通讯录管理系统
作者:
李思萌
日期:
2012-11-17
1.创建数据库DB_Address
脚本:
create database DB|_|Address
2.数据表脚本tb_Addresss
脚本:
create table
tb_Address
(
id int
identity primary key,
name nvarchar(10) not null,
sex nchar(1),
birthday datetime,
job nvarchar(100),
phone varchar(20),
qq varchar(20),
email varchar(100),
memo nvarchar(200)
)
3.数据库连接类ConnectDB.java
package commons;
import java.sql.*;
public class ConnectDB {
private static Connection con=null;
private static String url="jdbc:sqlserver://localhost:1433;databasename=DB_Address";
public static Connection
getConnection(){
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con=DriverManager.getConnection(url,"sa","123");
}catch(Exception e){
e.printStackTrace();
}
return
con;
}
public
static void main(String[] args) {
// TODO Auto-generated method stub
if(null==ConnectDB.getConnection())
{
System.out.println("连接失败");
}
else
{
System.out.println("连接成功");
}
}
}
4.数据验证类
MyRegex.java
package commons;
import java.util.regex.*;
public class MyRegex {
private
static boolean matcher(String pattern, String input)
{
Pattern p = Pattern.compile(pattern);
Matcher m = p.matcher(input);
return m.matches();
}
public
static boolean isId(String input) {
return matcher("\\d{1,5}$", input);
}
public
static bool